<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
        <button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
          @click="delTable">批量删除</button>
        <download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
          :type="exportExcel.type" :name="exportExcel.filename">
          <button class="uni-button" type="primary" size="mini">导出 Excel</button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList" :where="where" page-data="replace" :orderby="orderby"
        :getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
        v-slot:default="{ data, pagination, loading, error, options }" :options="options" loadtime="manual"
        @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection"
          @selection-change="selectionChange">
          <uni-tr>
            <uni-th v-if="$hasRole('admin')" align="center" sortable
              @sort-change="sortChange($event, 'user_id')">user_id</uni-th>
            <uni-th align="center">分类</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'title')" sortable
              @sort-change="sortChange($event, 'title')">标题</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'content')" sortable
              @sort-change="sortChange($event, 'content')">文章内容</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'excerpt')" sortable
              @sort-change="sortChange($event, 'excerpt')">摘要</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.article_status_localdata"
              @filter-change="filterChange($event, 'article_status')">文章状态</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.comment_status_localdata"
              @filter-change="filterChange($event, 'comment_status')">开放评论</uni-th>
            <uni-th align="center" sortable
              @sort-change="sortChange($event, 'last_comment_user_id')">last_comment_user_id</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'avatar')" sortable
              @sort-change="sortChange($event, 'avatar')">封面大图</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'publish_date')"
              sortable @sort-change="sortChange($event, 'publish_date')">发表时间</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'last_modify_date')"
              sortable @sort-change="sortChange($event, 'last_modify_date')">最后修改时间</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'mode')">排版显示模式</uni-th>
            <uni-th align="center">操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item, index) in data" :key="index">
            <uni-td v-if="$hasRole('admin')" align="center">{{ item.user_id }}</uni-td>
            <uni-td align="center">{{ item.category_id && item.category_id[0] && item.category_id[0].text }}</uni-td>
            <uni-td align="center">{{ item.title }}</uni-td>
            <uni-td align="center">{{ item.content }}</uni-td>
            <uni-td align="center">{{ item.excerpt }}</uni-td>
            <uni-td align="center">{{ options.article_status_valuetotext[item.article_status] }}</uni-td>
            <uni-td align="center">{{ options.comment_status_valuetotext[item.comment_status] }}</uni-td>
            <uni-td align="center">{{ item.last_comment_user_id }}</uni-td>
            <uni-td align="center">{{ item.avatar }}</uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.publish_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.last_modify_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">{{ item.mode }}</uni-td>
            <uni-td align="center">
              <view class="uni-group">
                <button @click="navigateTo('./edit?id=' + item._id, false)" class="uni-button" size="mini"
                  type="primary" :disabled=!hasUpdatePermission>修改</button>
                <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn"
                  :disabled=!hasDeletePermission>删除</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count"
            @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
  </view>
</template>

<script>
import { enumConverter, filterToWhere } from '../../js_sdk/validator/opendb-news-articles.js';
import { UPDATE_PERMISSION, DELETE_PERMISSION } from '../../utils/constants.js';

const db = uniCloud.database()
// 表查询配置
const dbOrderBy = '' // 排序字段
const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
// 分页配置
const pageSize = 20
const pageCurrent = 1

const orderByMapping = {
  "ascending": "asc",
  "descending": "desc"
}

export default {
  data() {
    return {
      hasUpdatePermission: false,
      hasDeletePermission: false,
      collectionList: [
        db.collection('opendb-news-articles')
          .field('user_id,category_id,title,content,excerpt,article_status,comment_status,last_comment_user_id,avatar,publish_date,last_modify_date,mode')
          .getTemp(),
        db.collection('opendb-news-categories')
          .field('name as text, _id')
          .getTemp()
      ],
      query: '',
      where: this.$hasRole('admin') ? '' : `'user_id' == '${uniCloud.getCurrentUserInfo().uid}'`,
      orderby: dbOrderBy,
      orderByFieldName: "",
      selectedIndexs: [],
      options: {
        pageSize,
        pageCurrent,
        filterData: {
          "article_status_localdata": [
            {
              "value": 0,
              "text": "草稿箱"
            },
            {
              "value": 1,
              "text": "已发布"
            }
          ],
          "comment_status_localdata": [
            {
              "value": 0,
              "text": "关闭"
            },
            {
              "value": 1,
              "text": "开放"
            }
          ]
        },
        ...enumConverter
      },
      imageStyles: {
        width: 64,
        height: 64
      },
      exportExcel: {
        "filename": "opendb-news-articles.xls",
        "type": "xls",
        "fields": {
          "user_id": "user_id",
          "分类": "category_id",
          "标题": "title",
          "文章内容": "content",
          "文章摘录": "excerpt",
          "文章状态": "article_status",
          "开放评论": "comment_status",
          "last_comment_user_id": "last_comment_user_id",
          "封面大图": "avatar",
          "发表时间": "publish_date",
          "最后修改时间": "last_modify_date",
          "排版显示模式": "mode"
        }
      },
      exportExcelData: []
    }
  },
  onLoad() {
    this._filter = {}
    this.hasUpdatePermission = this.uniIDHasPermission(UPDATE_PERMISSION)
    this.hasDeletePermission = this.uniIDHasPermission(DELETE_PERMISSION)
  },
  onReady() {
    this.$refs.udb.loadData()
  },
  methods: {
    onqueryload(data) {
      this.exportExcelData = data
    },
    getWhere() {
      const query = this.query.trim()
      if (!query) {
        return ''
      }
      const queryRe = new RegExp(query, 'i')
      return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
    },
    search() {
      const newWhere = this.getWhere()
      this.where = newWhere
      this.$nextTick(() => {
        this.loadData()
      })
    },
    loadData(clear = true) {
      this.$refs.udb.loadData({
        clear
      })
    },
    onPageChanged(e) {
      this.selectedIndexs.length = 0
      this.$refs.table.clearSelection()
      this.$refs.udb.loadData({
        current: e.current
      })
    },
    navigateTo(url, clear) {
      // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
      uni.navigateTo({
        url,
        events: {
          refreshData: () => {
            this.loadData(clear)
          }
        }
      })
    },
    // 多选处理
    selectedItems() {
      var dataList = this.$refs.udb.dataList
      return this.selectedIndexs.map(i => dataList[i]._id)
    },
    // 批量删除
    delTable() {
      this.$refs.udb.remove(this.selectedItems(), {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    // 多选
    selectionChange(e) {
      this.selectedIndexs = e.detail.index
    },
    confirmDelete(id) {
      this.$refs.udb.remove(id, {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    sortChange(e, name) {
      this.orderByFieldName = name;
      if (e.order) {
        this.orderby = name + ' ' + orderByMapping[e.order]
      } else {
        this.orderby = ''
      }
      this.$refs.table.clearSelection()
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    },
    filterChange(e, name) {
      this._filter[name] = {
        type: e.filterType,
        value: e.filter
      }
      let newWhere = filterToWhere(this._filter, db.command)
      if (Object.keys(newWhere).length) {
        this.where = newWhere
      } else {
        this.where = ''
      }
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    }
  }
}
</script>

<style></style>
